package sdk.webview.fmc.com.fmcsdk.db;


/**
 * H5的离线图片
 * Created by ydm on 2017/12/22.
 */

public class VIDEO {
    public static final String TABLE_NAME = "h5_videos";
    /** 工单ID */
    public static final String OWNERID = "ownerId";
    /** 工单名称*/
    public static final String OWNEROBJECT = "ownerObject";
    /**工单类型*/
    public static final String OWNERTYPE = "ownerType";
    /**视频服务器路径*/
    public static final String VIDEOURL = "videoUrl";
    /**视频本地路径*/
    public static final String VIDEOLOCALURL = "videoLocalUrl";
    /**视频唯一标识*/
    public static final String TIMESTAMP = "timeStamp";

    public static final String SYNC = "sync";
    /**是否上传*/
    public static final String ISUPLOAD = "isUpload";
    // 建表语句
    public static final String CREATE_SQL = "create table if not exists "
            + TABLE_NAME + "(" + "_id INTEGER PRIMARY KEY autoincrement,"
            + OWNERID +" TEXT,"
            + SYNC + " TEXT not null,"
            + OWNEROBJECT +" TEXT,"
            + VIDEOURL +" TEXT,"
            + TIMESTAMP +" TEXT,"
            + VIDEOLOCALURL +" TEXT,"
            + ISUPLOAD +" TEXT,"
            + OWNERTYPE + " TEXT"+")";
}
